﻿CREATE TABLE [dbo].[PaymentCycle]
(
	[Cycle] VARCHAR(50) NOT NULL, 
    [IsOffCycle] BIT NOT NULL DEFAULT 0, 
    [DisplayOrder] INT NOT NULL DEFAULT 0,
    CONSTRAINT [PK_Cycle] PRIMARY KEY NONCLUSTERED ([Cycle] ASC)
)

GO

CREATE CLUSTERED INDEX [IX_PaymentCycle_DisplayOrder] ON [dbo].[PaymentCycle] ([DisplayOrder])
